package cn.edu.zjgsu.ito.model;

public class TeacherModel {
	public static TeacherModel dao=new TeacherModel();
	
	public String selectTeaInfoSql="select * from teacher_info where tNo=?";
	public String selectTeaNameSql="select tName from teacher_info where tNo=?";
	public String selectAllTeaSql="select * from teacher_info order by tName";
	public String selectAllTttSql="select *from teacher_timetable group by uuid order by uuid desc";
	public String checkTeaPasSql="select * from teacher where tNo=?";
	public String updateTeaPasSql="update teacher set tPwd=? where tNo=?";
	public String selectTeaSql="select * from teacher_info where tNo=?";
	public String selectTeaGradeSql="select * from student_grade where uuid=?";
	public String selectTttSql="select * from teacher_timetable where tNo=? and termValue=?";
	public String selectTtt2Sql="select * from teacher_timetable where uuid=?";
	public String selectTtttSql="select max(termValue) from teacher_timetable where tNo=?";
	public String selectTgSql="select * from student_grade where uuid=?";
	public String selectTermSql="select distinct termValue from teacher_timetable where tNo=? order by termValue desc";
	public String selectAllTermSql="select * from term order by termValue desc";

}
